Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	10400
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.4 MiB
Average record size in memory	144.0 B

Variable types

DateTime	2
Categorical	5
Numeric	11

Alerts

`spotify_url` has a high cardinality: 1309 distinct values	High cardinality
`song` has a high cardinality: 1165 distinct values	High cardinality
`artist` has a high cardinality: 601 distinct values	High cardinality
`id` has a high cardinality: 1309 distinct values	High cardinality
`energy` is highly correlated with `loudness`	High correlation
`loudness` is highly correlated with `energy`	High correlation
`acousticness` is highly correlated with `energy`	High correlation
`energy` is highly correlated with `acousticness` and 1 other fields	High correlation
`loudness` is highly correlated with `energy`	High correlation
`week_start` is highly correlated with `week_end`	High correlation
`week_end` is highly correlated with `week_start`	High correlation
`acousticness` is highly correlated with `danceability` and 3 other fields	High correlation
`danceability` is highly correlated with `acousticness` and 2 other fields	High correlation
`energy` is highly correlated with `acousticness` and 3 other fields	High correlation
`instrumentalness` is highly correlated with `loudness`	High correlation
`key` is highly correlated with `acousticness`	High correlation
`loudness` is highly correlated with `energy` and 2 other fields	High correlation
`tempo` is highly correlated with `acousticness` and 2 other fields	High correlation
`valence` is highly correlated with `energy`	High correlation
`instrumentalness` has 5047 (48.5%) zeros	Zeros
`key` has 1031 (9.9%) zeros	Zeros

Reproduction

Analysis started	2022-02-23 06:52:09.183624
Analysis finished	2022-02-23 06:52:26.445494
Duration	17.26 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

week_start
Date

HIGH CORRELATION

Distinct	52
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	81.4 KiB

Minimum	2021-02-12 00:00:00
Maximum	2022-02-04 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

week_end
Date

HIGH CORRELATION

Distinct	52
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	81.4 KiB

Minimum	2021-02-12 00:00:00
Maximum	2022-02-04 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

spotify_url
Categorical

HIGH CARDINALITY

Distinct	1309
Distinct (%)	12.6%
Missing	0
Missing (%)	0.0%
Memory size	81.4 KiB

https://open.spotify.com/track/7hxHWCCAIIxFLCzvDgnQHX	52
https://open.spotify.com/track/2gMXnyrvIjhVBUZwvLZDMP	52
https://open.spotify.com/track/5nujrmhLynf4yMoMtj8AQF	52
https://open.spotify.com/track/5QO79kh1waicV47BqGRL3g	52
https://open.spotify.com/track/3U4isOIWM3VvDubwSI3y7a	52
Other values (1304)	10140

Length

Max length	53
Median length	53
Mean length	53
Min length	53

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	478 ?
Unique (%)	4.6%

Sample

1st row	https://open.spotify.com/track/7lPN2DXiMsVn7XUKtOW1CS
2nd row	https://open.spotify.com/track/7lPN2DXiMsVn7XUKtOW1CS
3rd row	https://open.spotify.com/track/7lPN2DXiMsVn7XUKtOW1CS
4th row	https://open.spotify.com/track/7lPN2DXiMsVn7XUKtOW1CS
5th row	https://open.spotify.com/track/7lPN2DXiMsVn7XUKtOW1CS

Common Values

Value	Count	Frequency (%)
https://open.spotify.com/track/7hxHWCCAIIxFLCzvDgnQHX	52	0.5%
https://open.spotify.com/track/2gMXnyrvIjhVBUZwvLZDMP	52	0.5%
https://open.spotify.com/track/5nujrmhLynf4yMoMtj8AQF	52	0.5%
https://open.spotify.com/track/5QO79kh1waicV47BqGRL3g	52	0.5%
https://open.spotify.com/track/3U4isOIWM3VvDubwSI3y7a	52	0.5%
https://open.spotify.com/track/5uEYRdEIh9Bo4fpjDd4Na9	52	0.5%
https://open.spotify.com/track/0VjIjW4GlUZAMYd2vXMi3b	52	0.5%
https://open.spotify.com/track/6cx06DFPPHchuUAcTxznu9	52	0.5%
https://open.spotify.com/track/6f3Slt0GbA2bPZlz0aIFXN	52	0.5%
https://open.spotify.com/track/02MWAaffLxlfxAUY7c5dvx	52	0.5%
Other values (1299)	9880	95.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
https://open.spotify.com/track/7hxhwccaiixflczvdgnqhx	52	0.5%
https://open.spotify.com/track/3faj6o0nohqv8mc5ri6enp	52	0.5%
https://open.spotify.com/track/2gmxnyrvijhvbuzwvlzdmp	52	0.5%
https://open.spotify.com/track/6uellqglwmcvh1e5c4h7ly	52	0.5%
https://open.spotify.com/track/45be4hxi0awgzxfztmp8jr	52	0.5%
https://open.spotify.com/track/4iunztcvt9difysszvsnvs	52	0.5%
https://open.spotify.com/track/2h1hypekgiqap439cx7gsx	52	0.5%
https://open.spotify.com/track/2vxelyx666f8uxcj0dzf8b	52	0.5%
https://open.spotify.com/track/21jgcnket2qwijldfupipb	52	0.5%
https://open.spotify.com/track/7qehsqek33rtcfnt9pfqlf	52	0.5%
Other values (1299)	9880	95.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

song
Categorical

HIGH CARDINALITY

Distinct	1165
Distinct (%)	11.2%
Missing	0
Missing (%)	0.0%
Memory size	81.4 KiB

Someone You Loved	52
Mood (feat. iann dior)	52
drivers license	52
When I See U	52
Circles	52
Other values (1160)	10140

Length

Max length	91
Median length	14
Mean length	18.13961538
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	419 ?
Unique (%)	4.0%

Sample

1st row	drivers license
2nd row	drivers license
3rd row	drivers license
4th row	drivers license
5th row	drivers license

Common Values

Value	Count	Frequency (%)
Someone You Loved	52	0.5%
Mood (feat. iann dior)	52	0.5%
drivers license	52	0.5%
When I See U	52	0.5%
Circles	52	0.5%
Shallow	52	0.5%
Lemonade (feat. Gunna, Don Toliver & NAV)	52	0.5%
Save Your Tears	52	0.5%
Before You Go	52	0.5%
Umsebenzi Wethu	52	0.5%
Other values (1155)	9880	95.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
feat	1947	5.6%
	1648	4.8%
with	682	2.0%
the	666	1.9%
you	641	1.9%
me	477	1.4%
i	366	1.1%
love	339	1.0%
remix	335	1.0%
lil	284	0.8%
Other values (1769)	27094	78.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

artist
Categorical

HIGH CARDINALITY

Distinct	601
Distinct (%)	5.8%
Missing	0
Missing (%)	0.0%
Memory size	81.4 KiB

Drake	333
Olivia Rodrigo	222
The Weeknd	221
Juice WRLD	220
Doja Cat	216
Other values (596)	9188

Length

Max length	115
Median length	11
Mean length	16.24788462
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	146 ?
Unique (%)	1.4%

Sample

1st row	Olivia Rodrigo
2nd row	Olivia Rodrigo
3rd row	Olivia Rodrigo
4th row	Olivia Rodrigo
5th row	Olivia Rodrigo

Common Values

Value	Count	Frequency (%)
Drake	333	3.2%
Olivia Rodrigo	222	2.1%
The Weeknd	221	2.1%
Juice WRLD	220	2.1%
Doja Cat	216	2.1%
Ed Sheeran	199	1.9%
Justin Bieber	192	1.8%
Pop Smoke	180	1.7%
Billie Eilish	170	1.6%
J. Cole	150	1.4%
Other values (591)	8297	79.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
de	511	1.8%
the	475	1.6%
dj	437	1.5%
drake	360	1.2%
mr	319	1.1%
jazziq	319	1.1%
sir	299	1.0%
trill	296	1.0%
929	295	1.0%
busta	295	1.0%
Other values (955)	25454	87.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

streams
Real number (ℝ_≥0)

Distinct	9097
Distinct (%)	87.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38669.19096

Minimum	16889
Maximum	429149
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	81.4 KiB

Quantile statistics

Minimum	16889
5-th percentile	19487
Q1	23950
median	29415.5
Q3	42691.25
95-th percentile	88485.45
Maximum	429149
Range	412260
Interquartile range (IQR)	18741.25

Descriptive statistics

Standard deviation	26868.48151
Coefficient of variation (CV)	0.694829161
Kurtosis	24.88422033
Mean	38669.19096
Median Absolute Deviation (MAD)	7149
Skewness	3.852420856
Sum	402159586
Variance	721915298.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24665	4	< 0.1%
28761	4	< 0.1%
23975	4	< 0.1%
22367	4	< 0.1%
22609	4	< 0.1%
21920	4	< 0.1%
23719	4	< 0.1%
30185	4	< 0.1%
22304	4	< 0.1%
26832	4	< 0.1%
Other values (9087)	10360	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
16889	1	< 0.1%
16919	1	< 0.1%
16950	1	< 0.1%
16979	1	< 0.1%
16989	2	< 0.1%
16999	1	< 0.1%
17020	1	< 0.1%
17031	1	< 0.1%
17076	1	< 0.1%
17084	1	< 0.1%

Value	Count	Frequency (%)
429149	1	< 0.1%
392465	1	< 0.1%
388818	1	< 0.1%
339963	1	< 0.1%
291545	1	< 0.1%
289365	1	< 0.1%
288009	1	< 0.1%
280674	1	< 0.1%
269570	1	< 0.1%
268731	1	< 0.1%

id
Categorical

HIGH CARDINALITY

Distinct	1309
Distinct (%)	12.6%
Missing	0
Missing (%)	0.0%
Memory size	81.4 KiB

2VxeLyX666F8uXCJ0dZF8B	52
5uEYRdEIh9Bo4fpjDd4Na9	52
7hxHWCCAIIxFLCzvDgnQHX	52
6f3Slt0GbA2bPZlz0aIFXN	52
3FAJ6O0NOHQV8Mc5Ri6ENp	52
Other values (1304)	10140

Length

Max length	22
Median length	22
Mean length	22
Min length	22

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	478 ?
Unique (%)	4.6%

Sample

1st row	7lPN2DXiMsVn7XUKtOW1CS
2nd row	7lPN2DXiMsVn7XUKtOW1CS
3rd row	7lPN2DXiMsVn7XUKtOW1CS
4th row	7lPN2DXiMsVn7XUKtOW1CS
5th row	7lPN2DXiMsVn7XUKtOW1CS

Common Values

Value	Count	Frequency (%)
2VxeLyX666F8uXCJ0dZF8B	52	0.5%
5uEYRdEIh9Bo4fpjDd4Na9	52	0.5%
7hxHWCCAIIxFLCzvDgnQHX	52	0.5%
6f3Slt0GbA2bPZlz0aIFXN	52	0.5%
3FAJ6O0NOHQV8Mc5Ri6ENp	52	0.5%
45bE4HXI0AwGZXfZtMp8JR	52	0.5%
2gMXnyrvIjhVBUZwvLZDMP	52	0.5%
6cx06DFPPHchuUAcTxznu9	52	0.5%
0VjIjW4GlUZAMYd2vXMi3b	52	0.5%
6ft4hAq6yde8jPZY2i5zLr	52	0.5%
Other values (1299)	9880	95.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2vxelyx666f8uxcj0dzf8b	52	0.5%
5nujrmhlynf4ymomtj8aqf	52	0.5%
5ueyrdeih9bo4fpjdd4na9	52	0.5%
4iunztcvt9difysszvsnvs	52	0.5%
2h1hypekgiqap439cx7gsx	52	0.5%
7qehsqek33rtcfnt9pfqlf	52	0.5%
6uellqglwmcvh1e5c4h7ly	52	0.5%
02mwaafflxlfxauy7c5dvx	52	0.5%
5qo79kh1waicv47bqgrl3g	52	0.5%
3u4isoiwm3vvdubwsi3y7a	52	0.5%
Other values (1299)	9880	95.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

acousticness
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	886
Distinct (%)	8.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2253694052

Minimum	3.84 × 10^-5
Maximum	0.978
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	81.4 KiB

Quantile statistics

Minimum	3.84 × 10^-5
5-th percentile	0.00262
Q1	0.0222
median	0.127
Q3	0.336
95-th percentile	0.768
Maximum	0.978
Range	0.9779616
Interquartile range (IQR)	0.3138

Descriptive statistics

Standard deviation	0.2504157341
Coefficient of variation (CV)	1.111134557
Kurtosis	0.4691952894
Mean	0.2253694052
Median Absolute Deviation (MAD)	0.1147
Skewness	1.218779074
Sum	2343.841814
Variance	0.06270803989
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.127	110	1.1%
0.487	80	0.8%
0.321	71	0.7%
0.21	67	0.6%
0.185	66	0.6%
0.604	65	0.6%
0.0212	62	0.6%
0.122	61	0.6%
0.181	60	0.6%
0.297	59	0.6%
Other values (876)	9699	93.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.84 × 10^-5	10	0.1%
0.000215	3	< 0.1%
0.000269	1	< 0.1%
0.000274	22	0.2%
0.000316	2	< 0.1%
0.000355	4	< 0.1%
0.000361	1	< 0.1%
0.000406	1	< 0.1%
0.000419	11	0.1%
0.0005	2	< 0.1%

Value	Count	Frequency (%)
0.978	13	0.1%
0.974	1	< 0.1%
0.967	6	0.1%
0.961	1	< 0.1%
0.957	1	< 0.1%
0.941	4	< 0.1%
0.937	11	0.1%
0.934	52	0.5%
0.932	2	< 0.1%
0.928	1	< 0.1%

danceability
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	495
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.6979378846

Minimum	0.161
Maximum	0.971
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	81.4 KiB

Quantile statistics

Minimum	0.161
5-th percentile	0.423
Q1	0.603
median	0.719
Q3	0.808
95-th percentile	0.883
Maximum	0.971
Range	0.81
Interquartile range (IQR)	0.205

Descriptive statistics

Standard deviation	0.1405247155
Coefficient of variation (CV)	0.201342725
Kurtosis	-0.1654311236
Mean	0.6979378846
Median Absolute Deviation (MAD)	0.103
Skewness	-0.6737793175
Sum	7258.554
Variance	0.01974719568
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.824	130	1.2%
0.671	117	1.1%
0.842	109	1.0%
0.695	100	1.0%
0.548	97	0.9%
0.798	94	0.9%
0.65	90	0.9%
0.841	88	0.8%
0.789	88	0.8%
0.632	87	0.8%
Other values (485)	9400	90.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.161	3	< 0.1%
0.234	2	< 0.1%
0.242	2	< 0.1%
0.269	2	< 0.1%
0.275	1	< 0.1%
0.28	1	< 0.1%
0.282	1	< 0.1%
0.308	1	< 0.1%
0.309	1	< 0.1%
0.311	19	0.2%

Value	Count	Frequency (%)
0.971	1	< 0.1%
0.969	1	< 0.1%
0.961	1	< 0.1%
0.957	5	< 0.1%
0.956	7	0.1%
0.953	12	0.1%
0.95	12	0.1%
0.945	2	< 0.1%
0.94	1	< 0.1%
0.935	26	0.2%

energy
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	530
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5923300769

Minimum	0.0474
Maximum	0.959
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	81.4 KiB

Quantile statistics

Minimum	0.0474
5-th percentile	0.34
Q1	0.488
median	0.5935
Q3	0.699
95-th percentile	0.825
Maximum	0.959
Range	0.9116
Interquartile range (IQR)	0.211

Descriptive statistics

Standard deviation	0.1495455318
Coefficient of variation (CV)	0.2524699278
Kurtosis	-0.2697959834
Mean	0.5923300769
Median Absolute Deviation (MAD)	0.1055
Skewness	-0.2050901265
Sum	6160.2328
Variance	0.02236386607
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.586	119	1.1%
0.593	106	1.0%
0.521	103	1.0%
0.449	101	1.0%
0.825	95	0.9%
0.609	89	0.9%
0.655	87	0.8%
0.784	86	0.8%
0.405	84	0.8%
0.72	82	0.8%
Other values (520)	9448	90.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.0474	2	< 0.1%
0.101	1	< 0.1%
0.111	13	0.1%
0.128	1	< 0.1%
0.13	1	< 0.1%
0.137	1	< 0.1%
0.155	1	< 0.1%
0.158	1	< 0.1%
0.159	1	< 0.1%
0.161	6	0.1%

Value	Count	Frequency (%)
0.959	1	< 0.1%
0.941	10	0.1%
0.935	2	< 0.1%
0.934	14	0.1%
0.925	1	< 0.1%
0.923	1	< 0.1%
0.917	1	< 0.1%
0.915	2	< 0.1%
0.913	15	0.1%
0.912	4	< 0.1%

instrumentalness
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	580
Distinct (%)	5.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.03461241302

Minimum	0
Maximum	0.938
Zeros	5047
Zeros (%)	48.5%
Negative	0
Negative (%)	0.0%
Memory size	81.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1.43 × 10^-6
Q3	0.000389
95-th percentile	0.312
Maximum	0.938
Range	0.938
Interquartile range (IQR)	0.000389

Descriptive statistics

Standard deviation	0.1352010721
Coefficient of variation (CV)	3.906144077
Kurtosis	21.30070163
Mean	0.03461241302
Median Absolute Deviation (MAD)	1.43 × 10^-6
Skewness	4.592899215
Sum	359.9690954
Variance	0.0182793299
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5047	48.5%
0.00122	62	0.6%
0.0192	54	0.5%
7.92 × 10^-5	53	0.5%
1.02 × 10^-6	53	0.5%
0.000307	53	0.5%
9.54 × 10^-5	52	0.5%
0.00244	52	0.5%
1.14 × 10^-5	52	0.5%
1.24 × 10^-5	52	0.5%
Other values (570)	4870	46.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5047	48.5%
1.01 × 10^-6	6	0.1%
1.02 × 10^-6	53	0.5%
1.03 × 10^-6	6	0.1%
1.04 × 10^-6	11	0.1%
1.09 × 10^-6	1	< 0.1%
1.18 × 10^-6	4	< 0.1%
1.22 × 10^-6	2	< 0.1%
1.23 × 10^-6	1	< 0.1%
1.24 × 10^-6	1	< 0.1%

Value	Count	Frequency (%)
0.938	3	< 0.1%
0.927	1	< 0.1%
0.925	4	< 0.1%
0.917	1	< 0.1%
0.903	26	0.2%
0.894	1	< 0.1%
0.889	3	< 0.1%
0.888	11	0.1%
0.887	7	0.1%
0.883	1	< 0.1%

key
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.415096154

Minimum	0
Maximum	11
Zeros	1031
Zeros (%)	9.9%
Negative	0
Negative (%)	0.0%
Memory size	81.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	6
Q3	9
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	3.751629193
Coefficient of variation (CV)	0.69280934
Kurtosis	-1.414435304
Mean	5.415096154
Median Absolute Deviation (MAD)	4
Skewness	-0.02459958912
Sum	56317
Variance	14.0747216
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	1704	16.4%
8	1134	10.9%
11	1052	10.1%
0	1031	9.9%
10	1018	9.8%
7	894	8.6%
6	733	7.0%
2	698	6.7%
5	670	6.4%
9	570	5.5%
Other values (2)	896	8.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1031	9.9%
1	1704	16.4%
2	698	6.7%
3	327	3.1%
4	569	5.5%
5	670	6.4%
6	733	7.0%
7	894	8.6%
8	1134	10.9%
9	570	5.5%

Value	Count	Frequency (%)
11	1052	10.1%
10	1018	9.8%
9	570	5.5%
8	1134	10.9%
7	894	8.6%
6	733	7.0%
5	670	6.4%
4	569	5.5%
3	327	3.1%
2	698	6.7%

liveness
Real number (ℝ_≥0)

Distinct	613
Distinct (%)	5.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1545553365

Minimum	0.0146
Maximum	0.97
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	81.4 KiB

Quantile statistics

Minimum	0.0146
5-th percentile	0.037795
Q1	0.0829
median	0.111
Q3	0.172
95-th percentile	0.405
Maximum	0.97
Range	0.9554
Interquartile range (IQR)	0.0891

Descriptive statistics

Standard deviation	0.1261537686
Coefficient of variation (CV)	0.8162368988
Kurtosis	6.170451538
Mean	0.1545553365
Median Absolute Deviation (MAD)	0.038
Skewness	2.235865195
Sum	1607.3755
Variance	0.01591477333
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.101	163	1.6%
0.12	151	1.5%
0.111	136	1.3%
0.106	126	1.2%
0.303	122	1.2%
0.109	122	1.2%
0.105	110	1.1%
0.129	105	1.0%
0.112	103	1.0%
0.124	101	1.0%
Other values (603)	9161	88.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.0146	15	0.1%
0.0176	1	< 0.1%
0.019	2	< 0.1%
0.0194	4	< 0.1%
0.0208	29	0.3%
0.0215	11	0.1%
0.0238	4	< 0.1%
0.0241	1	< 0.1%
0.0247	4	< 0.1%
0.0251	1	< 0.1%

Value	Count	Frequency (%)
0.97	2	< 0.1%
0.922	1	< 0.1%
0.854	2	< 0.1%
0.847	15	0.1%
0.844	1	< 0.1%
0.826	4	< 0.1%
0.79	23	0.2%
0.766	1	< 0.1%
0.74	1	< 0.1%
0.727	6	0.1%

loudness
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1146
Distinct (%)	11.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-7.683171635

Minimum	-24.279
Maximum	-2.018
Zeros	0
Zeros (%)	0.0%
Negative	10400
Negative (%)	100.0%
Memory size	81.4 KiB

Quantile statistics

Minimum	-24.279
5-th percentile	-13.334
Q1	-9.072
median	-7.222
Q3	-5.655
95-th percentile	-3.714
Maximum	-2.018
Range	22.261
Interquartile range (IQR)	3.417

Descriptive statistics

Standard deviation	2.93562707
Coefficient of variation (CV)	-0.3820853171
Kurtosis	1.63641736
Mean	-7.683171635
Median Absolute Deviation (MAD)	1.692
Skewness	-1.0796239
Sum	-79904.985
Variance	8.617906295
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-3.424	62	0.6%
-6.312	57	0.5%
-7.23	55	0.5%
-7.079	55	0.5%
-6.362	53	0.5%
-10.109	53	0.5%
-4.209	52	0.5%
-6.685	52	0.5%
-6.9	52	0.5%
-7.846	52	0.5%
Other values (1136)	9857	94.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-24.279	1	< 0.1%
-21.114	1	< 0.1%
-20.777	1	< 0.1%
-20.434	1	< 0.1%
-19.943	6	0.1%
-19.685	5	< 0.1%
-19.646	31	0.3%
-18.345	1	< 0.1%
-18.064	8	0.1%
-18.031	1	< 0.1%

Value	Count	Frequency (%)
-2.018	2	< 0.1%
-2.381	1	< 0.1%
-2.491	1	< 0.1%
-2.724	22	0.2%
-2.749	10	0.1%
-2.81	46	0.4%
-2.87	31	0.3%
-2.876	11	0.1%
-2.881	11	0.1%
-2.906	3	< 0.1%

speechiness
Real number (ℝ_≥0)

Distinct	689
Distinct (%)	6.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1067948462

Minimum	0.0232
Maximum	0.622
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	81.4 KiB

Quantile statistics

Minimum	0.0232
5-th percentile	0.031795
Q1	0.044975
median	0.0644
Q3	0.127
95-th percentile	0.342
Maximum	0.622
Range	0.5988
Interquartile range (IQR)	0.082025

Descriptive statistics

Standard deviation	0.09588905806
Coefficient of variation (CV)	0.8978809513
Kurtosis	2.593156157
Mean	0.1067948462
Median Absolute Deviation (MAD)	0.0277
Skewness	1.787286303
Sum	1110.6664
Variance	0.009194711455
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.242	126	1.2%
0.112	107	1.0%
0.2	101	1.0%
0.0341	88	0.8%
0.0347	82	0.8%
0.0324	72	0.7%
0.0299	72	0.7%
0.0309	71	0.7%
0.0345	70	0.7%
0.102	70	0.7%
Other values (679)	9541	91.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.0232	47	0.5%
0.0249	3	< 0.1%
0.0251	1	< 0.1%
0.0253	1	< 0.1%
0.0259	11	0.1%
0.0262	3	< 0.1%
0.0265	2	< 0.1%
0.027	48	0.5%
0.0276	1	< 0.1%
0.0279	1	< 0.1%

Value	Count	Frequency (%)
0.622	1	< 0.1%
0.583	1	< 0.1%
0.564	2	< 0.1%
0.526	2	< 0.1%
0.507	1	< 0.1%
0.491	1	< 0.1%
0.489	1	< 0.1%
0.487	29	0.3%
0.472	1	< 0.1%
0.47	4	< 0.1%

tempo
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1099
Distinct (%)	10.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	117.3425192

Minimum	61.311
Maximum	207.553
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	81.4 KiB

Quantile statistics

Minimum	61.311
5-th percentile	80.87
Q1	99.996
median	113.99
Q3	129.895
95-th percentile	166
Maximum	207.553
Range	146.242
Interquartile range (IQR)	29.899

Descriptive statistics

Standard deviation	24.24525953
Coefficient of variation (CV)	0.2066195586
Kurtosis	0.2830471497
Mean	117.3425192
Median Absolute Deviation (MAD)	14.942
Skewness	0.5621327813
Sum	1220362.2
Variance	587.8326095
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
113.001	95	0.9%
112.999	74	0.7%
113.012	74	0.7%
93.005	63	0.6%
112.995	62	0.6%
112.006	61	0.6%
120.031	59	0.6%
99.048	56	0.5%
112.008	55	0.5%
113.008	54	0.5%
Other values (1089)	9747	93.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
61.311	3	< 0.1%
65.136	1	< 0.1%
65.18	4	< 0.1%
65.988	13	0.1%
67.196	3	< 0.1%
67.238	1	< 0.1%
67.289	1	< 0.1%
68.004	2	< 0.1%
68.101	5	< 0.1%
70.956	1	< 0.1%

Value	Count	Frequency (%)
207.553	2	< 0.1%
205.863	5	< 0.1%
202.899	1	< 0.1%
201.739	2	< 0.1%
194.746	1	< 0.1%
192.099	19	0.2%
191.9	3	< 0.1%
188.7	1	< 0.1%
187.815	1	< 0.1%
185.972	1	< 0.1%

time_signature
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	81.4 KiB

4	9801
3	368
5	211
1	20

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	4
3rd row	4
4th row	4
5th row	4

Common Values

Value	Count	Frequency (%)
4	9801	94.2%
3	368	3.5%
5	211	2.0%
1	20	0.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
4	9801	94.2%
3	368	3.5%
5	211	2.0%
1	20	0.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

valence
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	628
Distinct (%)	6.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.4726255962

Minimum	0.0362
Maximum	0.969
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	81.4 KiB

Quantile statistics

Minimum	0.0362
5-th percentile	0.12
Q1	0.31
median	0.474
Q3	0.619
95-th percentile	0.862
Maximum	0.969
Range	0.9328
Interquartile range (IQR)	0.309

Descriptive statistics

Standard deviation	0.2155203844
Coefficient of variation (CV)	0.4560065857
Kurtosis	-0.6786731463
Mean	0.4726255962
Median Absolute Deviation (MAD)	0.155
Skewness	0.0732263228
Sum	4915.3062
Variance	0.04644903609
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.537	105	1.0%
0.437	105	1.0%
0.331	93	0.9%
0.543	92	0.9%
0.446	91	0.9%
0.436	82	0.8%
0.514	80	0.8%
0.494	76	0.7%
0.732	73	0.7%
0.553	73	0.7%
Other values (618)	9530	91.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.0362	1	< 0.1%
0.0374	1	< 0.1%
0.0381	1	< 0.1%
0.0382	1	< 0.1%
0.0387	1	< 0.1%
0.0393	3	< 0.1%
0.0397	30	0.3%
0.0498	3	< 0.1%
0.0524	1	< 0.1%
0.0534	1	< 0.1%

Value	Count	Frequency (%)
0.969	1	< 0.1%
0.967	1	< 0.1%
0.96	1	< 0.1%
0.958	21	0.2%
0.957	1	< 0.1%
0.947	4	< 0.1%
0.943	1	< 0.1%
0.942	10	0.1%
0.934	22	0.2%
0.931	11	0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	week_start	week_end	spotify_url	song	artist	streams	id	acousticness	danceability	energy	instrumentalness	key	liveness	loudness	speechiness	tempo	time_signature	valence
0	2021-02-12	2021-02-12	https://open.spotify.com/track/7lPN2DXiMsVn7XUKtOW1CS	drivers license	Olivia Rodrigo	96245	7lPN2DXiMsVn7XUKtOW1CS	0.721	0.585	0.436	0.000013	10	0.105	-8.761	0.0601	143.874	4	0.132
1	2021-02-19	2021-02-19	https://open.spotify.com/track/7lPN2DXiMsVn7XUKtOW1CS	drivers license	Olivia Rodrigo	92182	7lPN2DXiMsVn7XUKtOW1CS	0.721	0.585	0.436	0.000013	10	0.105	-8.761	0.0601	143.874	4	0.132
2	2021-02-26	2021-02-26	https://open.spotify.com/track/7lPN2DXiMsVn7XUKtOW1CS	drivers license	Olivia Rodrigo	85133	7lPN2DXiMsVn7XUKtOW1CS	0.721	0.585	0.436	0.000013	10	0.105	-8.761	0.0601	143.874	4	0.132
3	2021-03-05	2021-03-05	https://open.spotify.com/track/7lPN2DXiMsVn7XUKtOW1CS	drivers license	Olivia Rodrigo	81230	7lPN2DXiMsVn7XUKtOW1CS	0.721	0.585	0.436	0.000013	10	0.105	-8.761	0.0601	143.874	4	0.132
4	2021-03-12	2021-03-12	https://open.spotify.com/track/7lPN2DXiMsVn7XUKtOW1CS	drivers license	Olivia Rodrigo	73704	7lPN2DXiMsVn7XUKtOW1CS	0.721	0.585	0.436	0.000013	10	0.105	-8.761	0.0601	143.874	4	0.132
5	2021-03-19	2021-03-19	https://open.spotify.com/track/7lPN2DXiMsVn7XUKtOW1CS	drivers license	Olivia Rodrigo	70967	7lPN2DXiMsVn7XUKtOW1CS	0.721	0.585	0.436	0.000013	10	0.105	-8.761	0.0601	143.874	4	0.132
6	2021-03-26	2021-03-26	https://open.spotify.com/track/7lPN2DXiMsVn7XUKtOW1CS	drivers license	Olivia Rodrigo	67375	7lPN2DXiMsVn7XUKtOW1CS	0.721	0.585	0.436	0.000013	10	0.105	-8.761	0.0601	143.874	4	0.132
7	2021-04-02	2021-04-02	https://open.spotify.com/track/7lPN2DXiMsVn7XUKtOW1CS	drivers license	Olivia Rodrigo	64493	7lPN2DXiMsVn7XUKtOW1CS	0.721	0.585	0.436	0.000013	10	0.105	-8.761	0.0601	143.874	4	0.132
8	2021-04-09	2021-04-09	https://open.spotify.com/track/7lPN2DXiMsVn7XUKtOW1CS	drivers license	Olivia Rodrigo	61524	7lPN2DXiMsVn7XUKtOW1CS	0.721	0.585	0.436	0.000013	10	0.105	-8.761	0.0601	143.874	4	0.132
9	2021-04-16	2021-04-16	https://open.spotify.com/track/7lPN2DXiMsVn7XUKtOW1CS	drivers license	Olivia Rodrigo	57855	7lPN2DXiMsVn7XUKtOW1CS	0.721	0.585	0.436	0.000013	10	0.105	-8.761	0.0601	143.874	4	0.132

Last rows

	week_start	week_end	spotify_url	song	artist	streams	id	acousticness	danceability	energy	instrumentalness	key	liveness	loudness	speechiness	tempo	time_signature	valence
10390	2022-02-04	2022-02-04	https://open.spotify.com/track/0IuVhCflrQPMGRrOyoY5RW	she's all i wanna be	Tate McRae	36264	0IuVhCflrQPMGRrOyoY5RW	0.013400	0.614	0.644	0.000007	2	0.1170	-5.372	0.0426	160.036	4	0.6510
10391	2022-02-04	2022-02-04	https://open.spotify.com/track/2AAyBZmMVZSZfgzXRYJOWQ	emo girl (feat. WILLOW)	Machine Gun Kelly	28571	2AAyBZmMVZSZfgzXRYJOWQ	0.000406	0.410	0.881	0.000043	2	0.9220	-3.502	0.0870	165.006	4	0.3570
10392	2022-02-04	2022-02-04	https://open.spotify.com/track/10hMM5nsZQf66ldBlgWBfG	All For Us - from the HBO Original Series Euphoria	Labrinth, Zendaya	26159	10hMM5nsZQf66ldBlgWBfG	0.016500	0.348	0.652	0.000264	3	0.3300	-7.145	0.0931	70.956	4	0.1720
10393	2022-02-04	2022-02-04	https://open.spotify.com/track/3o9kpgkIcffx0iSwxhuNI2	Numb Little Bug	Em Beihold	24743	3o9kpgkIcffx0iSwxhuNI2	0.327000	0.742	0.527	0.000000	8	0.2500	-6.892	0.0769	84.974	4	0.6380
10394	2022-02-04	2022-02-04	https://open.spotify.com/track/3Oww84xrmgjyr5J1ilOmAf	Down Under (feat. Colin Hay)	Luude	24608	3Oww84xrmgjyr5J1ilOmAf	0.011600	0.308	0.860	0.000828	11	0.2770	-4.111	0.1680	171.835	4	0.0387
10395	2022-02-04	2022-02-04	https://open.spotify.com/track/3eRE1KwnUma75nu1HhoNY4	Can We Talk	Tevin Campbell	24499	3eRE1KwnUma75nu1HhoNY4	0.031200	0.660	0.646	0.000005	2	0.0330	-9.111	0.0426	172.376	4	0.6210
10396	2022-02-04	2022-02-04	https://open.spotify.com/track/6EtKlIQmGPB9SX8UjDJG5s	Formula	Labrinth	24146	6EtKlIQmGPB9SX8UjDJG5s	0.044800	0.574	0.664	0.055300	11	0.1460	-6.068	0.0409	144.654	4	0.2260
10397	2022-02-04	2022-02-04	https://open.spotify.com/track/7nHBwafnRUfqyJgg53xiVY	Ubusuku Bayizolo	Ntosh Gazi	23992	7nHBwafnRUfqyJgg53xiVY	0.024000	0.824	0.923	0.000000	0	0.0516	-3.468	0.0549	113.007	4	0.7510
10398	2022-02-04	2022-02-04	https://open.spotify.com/track/3zpGLSQ8QbbUnNjweWPLMD	Doja	$NOT, A$AP Rocky	23789	3zpGLSQ8QbbUnNjweWPLMD	0.072500	0.753	0.777	0.000714	11	0.1250	-5.701	0.3200	157.148	4	0.6690
10399	2022-02-04	2022-02-04	https://open.spotify.com/track/1iSiayhy8ewrs7Bb2g0du4	Stalling	Nasty C	23330	1iSiayhy8ewrs7Bb2g0du4	0.285000	0.705	0.593	0.000000	7	0.0986	-6.313	0.1890	98.921	4	0.3060

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows